SQL Interview Questions and Answers
Test your skills through the online practice test: SQL Quiz Online Practice Test
Ques 71. The Delete Statements:
DELETE FROM WITHOUTBOOK WHERE NAME='JOHN';
Is it helpful?
Add Comment
View Comments
Ques 72. Sort the Rows:
SELECT * FROM WITHOUTBOOK ORDER BY NAME ASC;
SELECT * FROM WITHOUTBOOK ORDER BY NAME DESC;
Is it helpful?
Add Comment
View Comments
Ques 73. The IN operator may be used if you know the exact value you want to return for at least one of the columns.
SELECT * FROM WITHOUTBOOK WHERE NAME IN(SELECT NAME FROM WITHOUTBOOK_BACK WHERE ADDRESS='KOLKATA, INDIA');
Is it helpful?
Add Comment
View Comments
Ques 74. BETWEEN ... AND
SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2 The values can be numbers, text, or dates.
Is it helpful?
Add Comment
View Comments
Ques 75. What is the use of CASCADE CONSTRAINTS?
When this clause is used with the DROP command, a parent table can be dropped even when a child table exists.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users: